
CREATE TABLE [dbo].[CashReceivedFromAgent_Log](
	[ReceiptID_log] [bigint] NOT NULL,
	[ReceiptID] [bigint] NOT NULL,
	[ReceiptNo] [varchar](50) NOT NULL,
	[Date] [datetime] NOT NULL,
	[DefaultBranchID] [bigint] NOT NULL,
	[AgentID] [bigint] NOT NULL,
	[UserID] [bigint] NOT NULL,
	[CurrencyID] [bigint] NOT NULL,
	[CurrencyRateID] [bigint] NOT NULL,
	[CurrencyRateDetailID] [bigint] NOT NULL,
	[Rate] [decimal](18, 4) NOT NULL,
	[TotalAmount] [decimal](18, 4) NOT NULL,
	[ReceivedAmount] [decimal](18, 4) NOT NULL,
	[BalanceAmount] [decimal](18, 4) NOT NULL,
	[BankID] [bigint] NULL,
	[log_sysDate] [datetime] NOT NULL,
	[log_userid] [bigint] NOT NULL,
	[log_status] [tinyint] NOT NULL
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO


